Tabela PerfContractService

Definicja tabeli PerfContractService

Name

PerfContractService

Code

PerfContractService

Comment

 


Lista kolumn tabeli PerfContractService

Name

Code

ContractServicePerfID

ContractServicePerfID

PerfOrgUnit

PerfOrgUnit

OrderingOrgUnit

OrderingOrgUnit

PerfPerson

PerfPerson

OrderingPerson

OrderingPerson

PerfDT

PerfDT

OrderDT

OrderDT

StopDT

StopDT

PointsPerUnit

PointsPerUnit

Teeth

Teeth

RescueLife

RescueLife

Comments

Comments

ConfirmDocumentNo

ConfirmDocumentNo

UnitsCount

UnitsCount

RateAdditional

RateAdditional

RateBase

RateBase

UnitPrice

UnitPrice

InsertDate

InsertDate

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

Con_ContractServID

Con_ContractServID

EventID

EventID

ContractorID

ContractorID

PerfContrServStatusID

PerfContrServStatusID

Per_ContractServicePerfID

Per_ContractServicePerfID

ContractID

ContractID

FinancedAccountingUnits

FinancedAccountingUnits

StatisticAccountingUnits

StatisticAccountingUnits

TotalStatisticDays

TotalStatisticDays

FinancedDays

FinancedDays

RecordServed

RecordServed

SettlementAnnexNumber

SettlementAnnexNumber

RateFactor

RateFactor

TariffRSElement

TariffRSElement

RateBaseOrginal

RateBaseOrginal

PointsPerUnitOrginal

PointsPerUnitOrginal

isBlockedForEdition

isBlockedForEdition

RateModifiersList

RateModifiersList

RateModifiersValues

RateModifiersValues

RateModifiersValuesOriginal

RateModifiersValuesOriginal


Kolumna ContractServicePerfID tabeli PerfContractService

Definicja kolumny ContractServicePerfID tabeli PerfContractService

Name

ContractServicePerfID

Code

ContractServicePerfID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfOrgUnit tabeli PerfContractService

Definicja kolumny PerfOrgUnit tabeli PerfContractService

Name

PerfOrgUnit

Code

PerfOrgUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingOrgUnit tabeli PerfContractService

Definicja kolumny OrderingOrgUnit tabeli PerfContractService

Name

OrderingOrgUnit

Code

OrderingOrgUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfPerson tabeli PerfContractService

Definicja kolumny PerfPerson tabeli PerfContractService

Name

PerfPerson

Code

PerfPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingPerson tabeli PerfContractService

Definicja kolumny OrderingPerson tabeli PerfContractService

Name

OrderingPerson

Code

OrderingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli PerfContractService

Definicja kolumny PerfDT tabeli PerfContractService

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna OrderDT tabeli PerfContractService

Definicja kolumny OrderDT tabeli PerfContractService

Name

OrderDT

Code

OrderDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli PerfContractService

Definicja kolumny StopDT tabeli PerfContractService

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna PointsPerUnit tabeli PerfContractService

Definicja kolumny PointsPerUnit tabeli PerfContractService

Name

PointsPerUnit

Code

PointsPerUnit

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna Teeth tabeli PerfContractService

Definicja kolumny Teeth tabeli PerfContractService

Name

Teeth

Code

Teeth

Data Type

VARCHAR2(60)

Mandatory

No

Comment

not used any more!

It contains information on teeth in contract services tha was gathered until 2006.
Now this information is stored in AttributeValues.


Kolumna RescueLife tabeli PerfContractService

Definicja kolumny RescueLife tabeli PerfContractService

Name

RescueLife

Code

RescueLife

Data Type

NUMBER(5)

Mandatory

No

Comment

True means that the contract service rescue sb life.
It is important while reporting (NFZ)


Kolumna Comments tabeli PerfContractService

Definicja kolumny Comments tabeli PerfContractService

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ConfirmDocumentNo tabeli PerfContractService

Definicja kolumny ConfirmDocumentNo tabeli PerfContractService

Name

ConfirmDocumentNo

Code

ConfirmDocumentNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli PerfContractService

Definicja kolumny UnitsCount tabeli PerfContractService

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(19,10)

Mandatory

No

Comment

 


Kolumna RateAdditional tabeli PerfContractService

Definicja kolumny RateAdditional tabeli PerfContractService

Name

RateAdditional

Code

RateAdditional

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna RateBase tabeli PerfContractService

Definicja kolumny RateBase tabeli PerfContractService

Name

RateBase

Code

RateBase

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna UnitPrice tabeli PerfContractService

Definicja kolumny UnitPrice tabeli PerfContractService

Name

UnitPrice

Code

UnitPrice

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli PerfContractService

Definicja kolumny InsertDate tabeli PerfContractService

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertingPerson tabeli PerfContractService

Definicja kolumny InsertingPerson tabeli PerfContractService

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli PerfContractService

Definicja kolumny LastModifiedDT tabeli PerfContractService

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli PerfContractService

Definicja kolumny LastModifiedPerson tabeli PerfContractService

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Con_ContractServID tabeli PerfContractService

Definicja kolumny Con_ContractServID tabeli PerfContractService

Name

Con_ContractServID

Code

Con_ContractServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli PerfContractService

Definicja kolumny EventID tabeli PerfContractService

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorID tabeli PerfContractService

Definicja kolumny ContractorID tabeli PerfContractService

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfContrServStatusID tabeli PerfContractService

Definicja kolumny PerfContrServStatusID tabeli PerfContractService

Name

PerfContrServStatusID

Code

PerfContrServStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Per_ContractServicePerfID tabeli PerfContractService

Definicja kolumny Per_ContractServicePerfID tabeli PerfContractService

Name

Per_ContractServicePerfID

Code

Per_ContractServicePerfID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractID tabeli PerfContractService

Definicja kolumny ContractID tabeli PerfContractService

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID umowy


Kolumna FinancedAccountingUnits tabeli PerfContractService

Definicja kolumny FinancedAccountingUnits tabeli PerfContractService

Name

FinancedAccountingUnits

Code

FinancedAccountingUnits

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Liczba jednostek rozliczeniowych zaakceptowana przez platnika do fakturowania


Kolumna StatisticAccountingUnits tabeli PerfContractService

Definicja kolumny StatisticAccountingUnits tabeli PerfContractService

Name

StatisticAccountingUnits

Code

StatisticAccountingUnits

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Liczba jednostek rozliczeniowych przekazana w komunikacie SWIAD wynikajaca z umowy (wynikajaca z wagi,taryfy i krotnosci)


Kolumna TotalStatisticDays tabeli PerfContractService

Definicja kolumny TotalStatisticDays tabeli PerfContractService

Name

TotalStatisticDays

Code

TotalStatisticDays

Data Type

NUMBER(10)

Mandatory

No

Comment

Calkowita liczba dni w których bylo udzielane swiadczenie finansowane dana pozycja rozliczeniowa (okreslona w atrybucie id-poz-rozl)


Kolumna FinancedDays tabeli PerfContractService

Definicja kolumny FinancedDays tabeli PerfContractService

Name

FinancedDays

Code

FinancedDays

Data Type

NUMBER(10)

Mandatory

No

Comment

Liczba dni finansowanych dana pozycja rozliczeniowa (okreslona w atrybucie id-poz-rozl)


Kolumna RecordServed tabeli PerfContractService

Definicja kolumny RecordServed tabeli PerfContractService

Name

RecordServed

Code

RecordServed

Data Type

NUMBER(5)

Mandatory

No

Comment

Kolumna konieczna jest dla mechanizmu synchronizacji statusów pozycji rozliczeniowych pomiedzy CN a STER, zastapi analogiczna kolumne z tabeli PerfContrServChangeLog.


Kolumna SettlementAnnexNumber tabeli PerfContractService

Definicja kolumny SettlementAnnexNumber tabeli PerfContractService

Name

SettlementAnnexNumber

Code

SettlementAnnexNumber

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Nr aneksu ugodowego.


Kolumna RateFactor tabeli PerfContractService

Definicja kolumny RateFactor tabeli PerfContractService

Name

RateFactor

Code

RateFactor

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna TariffRSElement tabeli PerfContractService

Definicja kolumny TariffRSElement tabeli PerfContractService

Name

TariffRSElement

Code

TariffRSElement

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy wprowadzona taryfa jest elementem podzialu ryzyka


Kolumna RateBaseOrginal tabeli PerfContractService

Definicja kolumny RateBaseOrginal tabeli PerfContractService

Name

RateBaseOrginal

Code

RateBaseOrginal

Data Type

NUMBER(12,4)

Mandatory

No

Comment

RateBase wyliczony przez groupera


Kolumna PointsPerUnitOrginal tabeli PerfContractService

Definicja kolumny PointsPerUnitOrginal tabeli PerfContractService

Name

PointsPerUnitOrginal

Code

PointsPerUnitOrginal

Data Type

NUMBER(12,4)

Mandatory

No

Comment

PointsPerUnit wyliczony przez groupera


Kolumna isBlockedForEdition tabeli PerfContractService

Definicja kolumny isBlockedForEdition tabeli PerfContractService

Name

isBlockedForEdition

Code

isBlockedForEdition

Data Type

NUMBER(3)

Mandatory

No

Comment

czy dany rekord jest zautoryzowany tj. zablokowany do edycji (zmiany), taki rekord moze byc zmieniany tylko z dodatkowym uprawnieniem -21039


Kolumna RateModifiersList tabeli PerfContractService

Definicja kolumny RateModifiersList tabeli PerfContractService

Name

RateModifiersList

Code

RateModifiersList

Data Type

VARCHAR2(512)

Mandatory

No

Comment

string powstaly ze sklejenia ID-ków
modyfikatorów ze slownika RateModifier wybranych dla danego swiadczenia


Kolumna RateModifiersValues tabeli PerfContractService

Definicja kolumny RateModifiersValues tabeli PerfContractService

Name

RateModifiersValues

Code

RateModifiersValues

Data Type

VARCHAR2(512)

Mandatory

No

Comment

string powstaly ze sklejenia par Code i ModifierValue modyfikatorów ze slownika RateModifier wybranych dla danego swiadczenia


Kolumna RateModifiersValuesOriginal tabeli PerfContractService

Definicja kolumny RateModifiersValuesOriginal tabeli PerfContractService

Name

RateModifiersValuesOriginal

Code

RateModifiersValuesOriginal

Data Type

VARCHAR2(512)

Mandatory

No

Comment

string powstaly ze sklejenia par Code i ModifierValue modyfikatorów ze slownika RateModifier wybranych dla danego swiadczenia które zwrócil gruper (nie sa zmienione przez uzytkownika)


Lista kluczy tabeli PerfContractService

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PerfContractService

Definicja klucza Identifier_1 tabeli PerfContractService

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment